UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+gUCOnvHt+ohL/2Yvq+8Vde5y2ohN4Rqyaj+OEcNKE='
WHERE
key_id = 'cde46ab85dc56624b0b5a4d71c3310a313b79bbae527e12d145e9052de65ca58'
AND (
token = 'W+gUCOnvHt+ohL/2Yvq+8Vde5y2ohN4Rqyaj+OEcNKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)