UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MWRiZ4eYqbKHFcYvOANGpOpi/7pnzifkpd3f3a7QqJ0='
WHERE
key_id = '917bc63119bab223bdfec20bfc93e43b211f4164680648b4f0e7737ada6ba6a1'
AND (
token = 'MWRiZ4eYqbKHFcYvOANGpOpi/7pnzifkpd3f3a7QqJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)