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