UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8jgfX9PYCuxCUuHyN/FjXzuUZN2IQZ+H2KiYZN5+w9g='
WHERE
key_id = 'e9a757bb3c66284e29035a7cf489dcfffac1d08d3a3f36ac15137a5a5e3c5650'
AND (
token = '8jgfX9PYCuxCUuHyN/FjXzuUZN2IQZ+H2KiYZN5+w9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)