UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZSHDZTWB0NrV9X0MYJm73q/fBu0ec4wJ2fBO+fLffg='
WHERE
key_id = '9d8e3b2af694d9ebaf1175b066df4042437abb5833e95a85d30092d00e796152'
AND (
token = 'pZSHDZTWB0NrV9X0MYJm73q/fBu0ec4wJ2fBO+fLffg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)