UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HYJSIe23uH+2xpYiNByqu1UXN74BHKW1hj1ns4jU5pI='
WHERE
key_id = 'e69c513402ec3cce5987b965d31635f667c43873ae79d5f8eaa27d2b4fd68ea9'
AND (
token = 'HYJSIe23uH+2xpYiNByqu1UXN74BHKW1hj1ns4jU5pI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)