UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QpIGAVSwtwNeXqlHb01GSGqONd4Ld6C7paXyWyfMkm0='
WHERE
key_id = '6c8772de19df98cb39f5ae6615e5a0f72802e99037d90cb2d79fc3de14ede2ec'
AND (
token = 'QpIGAVSwtwNeXqlHb01GSGqONd4Ld6C7paXyWyfMkm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)