UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eogn8BwPu8uxEdyLlo4NI2tTw6kwWznk2Ia13PvWzzI='
WHERE
key_id = '2672560a9bcd46cadcfe4c39fffe3a79c0faf52b3ac2c2f3e41736b5eddaabf9'
AND (
token = 'eogn8BwPu8uxEdyLlo4NI2tTw6kwWznk2Ia13PvWzzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)