UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X+yMGErRIzzNd9FdUoznjPK0BqHcTfnd4YtRi9c5JkQ='
WHERE
key_id = 'f3d77b08a6b0b7a587068e8db258e705cb314c81e427d0007d477a6ebd6f5b5d'
AND (
token = 'X+yMGErRIzzNd9FdUoznjPK0BqHcTfnd4YtRi9c5JkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)