UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06hpcos773oI5t844+yxul1vR6dKaJv11ExQzImr+QI='
WHERE
key_id = '1442c4a166ad85ccdf03f905f818a11766af2a6ab7a0eab18722da6549d9ba00'
AND (
token = '06hpcos773oI5t844+yxul1vR6dKaJv11ExQzImr+QI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)