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