UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ccQxl1+sa6Hgd/O/goWsyoa8e+wb3kEFYIdfGzjgd8='
WHERE
key_id = 'b2d5e96a18e4e697afad758fd25528c4d2a800a127b0a37f270c3b835198339b'
AND (
token = '1ccQxl1+sa6Hgd/O/goWsyoa8e+wb3kEFYIdfGzjgd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)