UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpTS1hdUIgbwDbeUK4vCp16H3ybT+ucZtVu1FSCRLVs='
WHERE
key_id = 'a7187a3a4928666a2e6f5cafcb5f55f9e569f4e7d2d6fe6bec554a346c2a4810'
AND (
token = 'hpTS1hdUIgbwDbeUK4vCp16H3ybT+ucZtVu1FSCRLVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)