UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0xfoyuvyZPsiRmG/UwTnuiwbGAcRAsJAra1Qlot+RSg='
WHERE
key_id = '506a03d136530cc30c611c4951d6a385271afe797f6a41dc61821e76ac333432'
AND (
token = '0xfoyuvyZPsiRmG/UwTnuiwbGAcRAsJAra1Qlot+RSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)