UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kSTL8rfswfxTxo8zdTj84XMttfd8EkX+KhSTXWXBulU='
WHERE
key_id = 'a4da8677f4aae027d3165cd8065cb548a9b1e4db861ae72b65fa12d42a7b6c6c'
AND (
token = 'kSTL8rfswfxTxo8zdTj84XMttfd8EkX+KhSTXWXBulU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)