UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xnVfZQK+kyQduosOms1J+V5G7KGj6La7U8pcT2Geyw='
WHERE
key_id = '737b118937c8e38cce567f8e41a4e86ef7c2b90ab8bb1ac1a18b08677b1fee29'
AND (
token = '0xnVfZQK+kyQduosOms1J+V5G7KGj6La7U8pcT2Geyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)