UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRuoN4sUYh6tQ20zo/5u4zOApf2xqPtvGYLuVDuAJOE='
WHERE
key_id = '3fd304cce91c98ed177f638d348b485a227c91d5db10102f85a530250af87071'
AND (
token = 'xRuoN4sUYh6tQ20zo/5u4zOApf2xqPtvGYLuVDuAJOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)