UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd3QzW2MmmWHanJpjvTDM5VOSpE6LR88+U9HcYNafFTk='
WHERE
key_id = 'e15ff8264d453b0157c15a4f3d914e0a24660ddce4c82efd244fd219a4d69958'
AND (
token = 'd3QzW2MmmWHanJpjvTDM5VOSpE6LR88+U9HcYNafFTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)