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