UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HbH2dp3bJPDLmxH2Zg2yiQgCsNG/1/XMRX1/mf0iyIg='
WHERE
key_id = 'd0b432fb753612388436ecbd8a16c76333dc7944c328a00ad29fce50761dc148'
AND (
token = 'HbH2dp3bJPDLmxH2Zg2yiQgCsNG/1/XMRX1/mf0iyIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)