UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NdYLJOXx/hSYthirIcIho5kh4Hu2DtAWdVQhah6PDc='
WHERE
key_id = '4547b9040907ef52dc498fcaab4f7504873b90c7df049b606b5ca03379935365'
AND (
token = '3NdYLJOXx/hSYthirIcIho5kh4Hu2DtAWdVQhah6PDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)