UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'roGbK7ozRVipINDPfu8wJCvz6GO7KIvm6THgRmiPjWA='
WHERE
key_id = '9fa825f42dc308a89edb4183b4c320e9af1188e3a06d92f4817133d76a88080b'
AND (
token = 'roGbK7ozRVipINDPfu8wJCvz6GO7KIvm6THgRmiPjWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)