UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P2peCvPrEZOe1J8gpLeELSx0VlsGLI7f3i1+uLx9urk='
WHERE
key_id = '1af6a8a0bbc3a7e571c173c26a32ade984fb132992aabea4f0f5bc5b34e8f66d'
AND (
token = 'P2peCvPrEZOe1J8gpLeELSx0VlsGLI7f3i1+uLx9urk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)