UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qcaISj21zzEd44Vm7ZrH4inUxRk76kSSwnpvpMGXxeY='
WHERE
key_id = 'ce770150a416a7ebd40bfed0458788075c0f5ee9cb250b6d575c9803e4fd4ea7'
AND (
token = 'qcaISj21zzEd44Vm7ZrH4inUxRk76kSSwnpvpMGXxeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)