UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hH5zOHet1P0c3VevN7YumQN6Rm53c/x9io5wFxW6GlI='
WHERE
key_id = 'b830144159857740671c9eb188b13799bc6642e8a0dd84766cbf203f6b3749c8'
AND (
token = 'hH5zOHet1P0c3VevN7YumQN6Rm53c/x9io5wFxW6GlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)