UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0lCodtKiFB90cKuUCCgW9ZUxqI3u4I81RdrH5ELX43c='
WHERE
key_id = '12129448c67c9a306671a774d74f298e83e44aa183a253de527d13538c57ab51'
AND (
token = '0lCodtKiFB90cKuUCCgW9ZUxqI3u4I81RdrH5ELX43c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)