UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tqO505eS+l989DME2Qo7x4bWXgnGXOb0/mdHQne6v4='
WHERE
key_id = '6d7770ebcdae0a0bd40b2eff3f998ec59384d4f5d16a48f6ab95bc6bea3996f3'
AND (
token = '9tqO505eS+l989DME2Qo7x4bWXgnGXOb0/mdHQne6v4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)