UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VlWk4NIF/49TZPNhoS92kdb+2sLvRuA36pw3W9nhVqg='
WHERE
key_id = '3a77e4c70625763abdf4afd0e7dd699d77dacde3c0baa08c62cc51413db15078'
AND (
token = 'VlWk4NIF/49TZPNhoS92kdb+2sLvRuA36pw3W9nhVqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)