UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/K7gmnHlyGCpHeEuw7cd8bZESOfGgfcqXL6Hy5PXAxw='
WHERE
key_id = 'ac18c007f0f3b3250cdcbbe413cc9db8d206f153c9a742c02bb203ed39d76d75'
AND (
token = '/K7gmnHlyGCpHeEuw7cd8bZESOfGgfcqXL6Hy5PXAxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)