UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0e2GPrD2BI5QdY5HA5J9Aj3ZIR3NvesdlwWZLXFx9Es='
WHERE
key_id = '232f75333aa87eb6971d654e046a7684261095a87505696419be6cd5e0a71f45'
AND (
token = '0e2GPrD2BI5QdY5HA5J9Aj3ZIR3NvesdlwWZLXFx9Es='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)