UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rEsBl8Fii7zBHQ8N/RjoKWhO0YRZp995MXFTWnPumSk='
WHERE
key_id = '50bdf9c9ddec219800f98277c1badde8b6b70731e1a21552ceb85bef3698b527'
AND (
token = 'rEsBl8Fii7zBHQ8N/RjoKWhO0YRZp995MXFTWnPumSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)