UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XR97+U8Y51dAy3frOG3FsIP+pW+K4caZleFMTNajCUM='
WHERE
key_id = '60bec4a9d362528c050423bf0d068ecd9a1c569ec3cf7554dda7a1a74c68e174'
AND (
token = 'XR97+U8Y51dAy3frOG3FsIP+pW+K4caZleFMTNajCUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)