UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6K+RmnRJ5Msawiz+R9u49OF95S52DFfbdqVpc/o/2tI='
WHERE
key_id = '9586bb311ddadfecf8de4a453bb7ac13da58f14ece0510fc3c9776649ece3ba0'
AND (
token = '6K+RmnRJ5Msawiz+R9u49OF95S52DFfbdqVpc/o/2tI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)