UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5tvCYbyM60mg5iLytjVKZeNsBbljH2rCfQb6dnVq8+c='
WHERE
key_id = '8b5ecc9c29d320bd46f46b698c3617298f2d2f0414913937b030dd54ef79ce44'
AND (
token = '5tvCYbyM60mg5iLytjVKZeNsBbljH2rCfQb6dnVq8+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)