UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nGRIGdsj9fRw9oJPU8z19nRynhwFPPBWBDX/V5+qfpI='
WHERE
key_id = '3c40769b38aabd99470450cda3b0e105b182165b896de1dace8c33d07ef51250'
AND (
token = 'nGRIGdsj9fRw9oJPU8z19nRynhwFPPBWBDX/V5+qfpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)