UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SBN54nZVJ12r4H2LQQ1aRuuWx4hAbA9Zhv1WO8oMrgw='
WHERE
key_id = 'c40f31358ba02c11df6fdce58c324bec701681c384870918fc11dfd2a92eff0b'
AND (
token = 'SBN54nZVJ12r4H2LQQ1aRuuWx4hAbA9Zhv1WO8oMrgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)