UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0+RgAauz1tLkXQEb613dhfypD5zGbSpMG3V4G/1Xg4k='
WHERE
key_id = 'd43e06e3cb8f5a038d5c72cdc851d4ead75417893c1df4bac3ce5cbf12b269ae'
AND (
token = '0+RgAauz1tLkXQEb613dhfypD5zGbSpMG3V4G/1Xg4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)